I saw one of http://fountaincan.com/solid_copper_watering_can_floating_faucet_fountain.html">these</a> today @ Cracker Barrel and it looks like it would be a cinch to make. I peeked inside and there's just a pump with the clear tube (like the kind of rigid tube you'd use for an under-gravel filter) attached to the pump and the faucet attached to the clear tube. There's a hole drilled in the other side of the watering can that you can't see for the pump's electrical cord.
[IMG]http://www.fountaincan.com/cgi-bin/image/templates/TFC-3005.jpg alt="" />
[IMG]http://www.fountaincan.com/cgi-bin/image/templates/TFC-3005.jpg alt="" />