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.
3. Seal the inside of the pot -- whether it's terra-cotta, wood, or some other porous material -- with a liquid water sealant that is labeled for use on wood. Let the sealant dry completely.
4. Elevate the pump in the center of the container. Place it on bricks to bring it a few inches below where the water's surface will be. Fill the pot with water and connect the pump to the GFCI outlet. Be sure the water level does not dip below the pump.