Fountain in a Pot
One of the simplest water features you can make is a fountain in a container, like this one.
Use any large pot. Terra-cotta is particularly handsome. If the container does not have a drainage hole in the bottom, drill one (using a masonry bit) or drape the pump's electrical cord over the rim. Disguise the cord by guiding a few stems of one of the surrounding plants along the rim. Set the freestanding fountain in a garden bed or border that has an electrical outlet nearby; using an extension cord is not recommended. If you think you will have a problem with mosquitoes, add a few small goldfish, which will eat the larvae. The number of fish you can use -- probably not more than two or three -- will depend on the diameter and depth of the container.