Http://www.Hgtv.com/hgtv/gl_containers_pots/article/0,1785,HGTV_3562_1382821,00.html

Remember that pet stores make a great place to look for water pumps to pull the water from your basin back to the top of the water fall.

You might could even take the simple approach and just cement rocks to an aquarium pump placed inside a bowl.

If you choose a submersible pump, clear tubing can be purchased from your local hardware store like Home Depot.

Good luck.

It’s not really a big deal. . Trust me. . !!
v did one for our school project. . .
all you require is a motor which pumps the water. .

If u ask in retail store for the one to be used for waterfalls they’ll give you. .
There are many with varying power, select the one which ever suits your requirement.
And for building the waterfall. . Use thermocole . . . . Powder them. . Take plaster of Paris or fevicol kind of thing. . . Mix them along with thermocol in water and make mountain out of it, make a few steps also(looks good). .
and then use your fabric colors to colour the mountain. . . Create a pond where the water is led to ultimately. . .

put down ur thinking hats. .

All ur creativity in it, add a few trees here and t . . Few animals. .

A small bridge. .

And on and on. . Depending on your creativity. . .
after the whole model is complete. . . Now connect a plastic tube from the pond to a trough in which the moter is also placed and take another tube from the motor to the top of the mountain. . . Hence you would b recycling the same water. . !!
if its a long time project, you can keep changing the water once a while. . .
i hope the following sites can be of some use:

Http://www.Ehow.com/how_18042_make-tabletop-fountain.html
http://www.Landscapemodeling.org/html/tutorials/Waterfall.pdf

Good Luck. . !!

I did one be4, just make it out of clay