What you will need:
Pick a design ( country, zen, whimsical, art deco)
The reservoir (basin, bowl or bucket to hold the water.
Fountain Pump (size will depend on the height of the fountain)
Tubing (copper or vinyl)
The waterfall or fountain: It may be just the end of the tube covered with rocks or glass. A sculpture or artifact that you can drill a hole so the tubing can be inserted through it. A store bought fountain spray, or tea cups that allow the water to cascade down to the reservior. Different shapes of copper tubing that have small holes drilled into it. These are just some ideas.
Assemble your fountain, keeping in mind that the tubing should be secured to the pump and make sure that the water that comes out at the top of the fountain pours back into the reservior.
Fill your fountain with distilled water and plug in the pump.