Check out this part 1 video of How to Make a Waterfall in your very own yard.  Some really good design tips here.

Part 2:

Part 3.