I've seen some pumps in the chicago tools catalog that look like they might
do a waterfall.. or any online inexpensive alternatives would also be good.

You really need to look at the unit cost of water moved. Cost of operations
can really get ya. The Sequence 750 is one of the most cost effective gallons-
moved-to-watts-burned pumps on the market.

C//