Check this out:
How to make a waterfall (rainforest edition)

The guy has a ton of really cool tank feature ideas/instructions. This waterfall especially is what makes me want to paint the great stuff.