Here's how to make a simple outdoor fountain that looks as if a small urn is continually overflowing into a larger basin. I wanted to have an aged and organic look, as if some ancient urn had happened to get stuck in the weeds on a river. The only tricky part of this project is that the tube from the fountain pump needs to enter the urn below the water level, so you need a tight seal to keep all the water from leaking back out around the tube.
Large pot or basin
Large decorative stones
Small decorative stones
Two sticks of bamboo
Sugru or some other type of sealing goo
Drill, drill press or Dremel
Step 1: Preparing the Small Pot
Start with a decorative pot that fits the aesthetic you're looking for. I'm pretty sure I picked this one up at Home Depot.
Once you've got your pot, drill a hole just a little larger than the outer diameter of the tubing that comes with your pump. A drill press is ideal here, but if you don't have one you can get by with a drill or dremel. Clean and sand the area around the hole.
Step 2: Insert and Attach Tubing
Insert the tubing through the bottom of the hole so there's about a quarter inch on the inside, and then seal the hole with some sort of waterproof putty or goop. I originally tried some kind of marine epoxy putty, but that hardened rigid and when the tubing moved the seal would break.
For this latest attempt I tried using Sugru, which cures as a pliable silicone and should form better seal (it's only been running for a few hours, so I'll have to update this Instructable in a week or three with how well it has held up). One worry I have is that Sugru apparently isn't good at attaching to brass, but so far the seal seems to be holding up.
I just used one 5g packet of Sugru, split it into two pieces, and packed each piece around the tubing with one on each side of the hole. Dip your fingers in soapy water to keep the Sugru from sticking to them instead of the pot and tubing, and be sure to completely seal the hole.
Step 3: The Rest of the Fountain
The rest of the fountain is straightforward. Start with a large basin; in my case I used a large flower pot from Home Depot, but use whatever fits the look you're going for. Put the pump in the bottom, and run the power cord out over the back where it can be hidden by other elements of the fountain. Cover the pump with some large decorative rocks.
The next step is building a cradle for the pot. Take two lengths of bamboo and cut them down so they can lie across the top of the basin with a little extra extending on either side. A notch in each end of the bamboo will allow it to fit over the edge of the basin and hold it in place. That will give you a steady platform to lean your pot against so you can set it to whatever angle you want. I did this with the rear stick, but left the front one un-notched so I could move adjust the pot easily. The bamboo alone is enough to hold the pot in place, but it's easier if you stack your large rocks to where you can rest the pot on them as well.
Finally, fill the pot with enough small decorative rocks that the hole and tubing is completely covered, making sure none of the rocks are small enough that they'll get into the tube itself.