Howdy & Welcome to MFK,
First of all, I moved your thread to the set up forum, it has a better home here

For some more information than this thread mmight yield, I recommend the search option on this website. It will show you old threads and lots of opinions. There are some reoccurring themes, like sand as substrate, that you might want to read up on. Or just trust my expert opinions
GumbyBC said:
What are the ins and outs of substrate? I am not really a fan of the small rocks that everyone sells. Is there a good sand substrate that can be used for fresh water tanks?
Play sand from a home inprovement store

(anyone else? Rallysman?

)
GumbyBC said:
Specialty filters? Are hang-on power filters enough for a small tank with a light bio-load? What about a larger bio-load?
I am a canister guy, and I would never recommend anything but an Eheim filter. It pays off greatly throughout the years. You read about Rena or Fluval failing, but I have yet to hear about an Eheim biting the dust...
GumbyBC said:
Planted tanks? I have seen so many planted tanks that are just as amazing as a full blown reef. What are the requirements to keep a successful planted tank? A good source for freshwater plants?
Check out our planted tank forum. Lots of info there. Some fish do not tolerate plants, but for those which do, it provides a nicer environment and also helps with water quality. And it looks great. Use some substrate fertilizer in your sand (sand is great for plants). Again, check out also old threads in the plants forum
Again, welcome here at MFK!
HarleyK