We purchased this fountain to drown out some highway noise by our house.  It accomplishes that, but is slightly distracting as it sounds like a faucet rather than a nice, trickling fountain.  Also looks cheap.  

Pros: Easy to install
Cons: Distracting faucet sound, looks cheap