I'd kind of like to do the equivalent of an a in one tank for freshwater. Any suggestions?
If you want your typical "first aquarium" type of FW setup, you can just visit one of the major chains, get one of the "complete" setups a few decorations and plastic plants, and your good to go.
However, if you want a more advanced FW system, your going to fing yourself shopping around for a lot of advanced equipment. Advanced FW planted tanks can be about as complex as a reef system, and while not as expensive, they are not cheep either.
You will also find that while the goal of keeping a FW system going is the same as a SW system, how your get there is quite a bit different. Here are a few of the differences.
FW planted systems love canister filters. That they become a "nitrate factory" is not an issue. The plants consider the food. You can use a sump, but it's not ideal because it lets CO2 gas off. Plants like CO2.
High light FW planted systems use far less light than SW reef systems. A 2 or 4 bulb T5 fixture is more than enough for even the largest tanks.
High light FW systems typically use CO2 injection to get best growth out of the plants and keep down algae. This is where you spend the money you saved on lighting (grin).
One of the hardest mindsets to over come between SW reef systems and FW planted systems is that in a SW reef system you try and export nitrates and phosphates. In a FW planted system you usually need to add them.