The TAPI by Dreamfarm turns any faucet into drinking fountain! Just attach the rubber nipple to any faucet, squeeze and voila! You have a very colorful inexpensive water fountain. Would be good for kids bathroom.
Dog Pond - Place a plastic kiddie pool in the ground. It'd be easy to clean and looks nicer than having it above ground. Big dogs can't chew it up or drag it around. This is obviously more fancy than a plastic kiddie pool underground, good idea thou