Down Sacramento way this is how the ladies of The Sacramento Bee make a simple garden fountain when the cookies are baking in the oven. It is well worth watching this 3 minute video on Howcast if you are serious about putting together a garden or tabletop fountain. It is also worth noting that the spokesperson Gwen Schoen omits to tell us two important things: how the water pump gets powered and where the water comes from (is it the same water used over and over?), so you need to ask someone at the craft store, hardware shop or gardening center to explain this when you buy the pump.
Okay, what you need is a water pump, rubber hose, flower pots, a cork, cobble stones, water and water plants. You need a small pot to work in conjunction with a larger pot. You really need to watch the video to get a measure of this. The pump you need should be able to pump water to a height of 12″ to 24″ and the lower pot should be deep enough for you to submerge the pump entirely. This pot must also be one that does not rust or leak. As long as you know how the pump is being powered and where the water comes from, making this simple garden fountain should be a breeze — if you follow Gwen’s video closely.