Before going out and digging a hole in your yard, why not start with something small, like a fountain in a pot. I made one with a 1/2 whiskey barrel that turned out pretty cute. You can find all the parts you need, including the whiskey barrel at a large home improvement center. If the whiskey barrel idea doesn't appeal to you, use a ceramic pot. Just make sure it's glazed so it will hold water (without a hole in the bottom would be good, too).