http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=4385900764&category=20507

but do not know how to make it work without a pond. I do know that I would need to buy a pump, but don't know what else to get, or what the next step is. I would love to incorporate
something like this

http://cgi.ebay.com/Pottery-Barn-RED-PARTY-BUCKET-Metal-Ice-Partyware-NIB_W0QQitemZ4457514704QQcategoryZ79691QQssPageNameZWDVWQQrdZ1QQcmdZViewItem

since we have a lot of red in the yard. Would I have to drill a hole? Make a stand in the middle? I'm lost. Thanks if you can help!

Did you get the fountain hooked up?
You shouldn't need to drill a hole. Just set the pump in the bucket with the tubing (connects to the dog) and the electrial wire going over the back of the tub. Once it's set up and water running you'll barely notice the wire.