I've had this for a month now. I bought it for my mini schnauzer after learning how bacteria can grow in still dog bowl water, even with regular cleaning. Assembly was fairly easy, and it comes with a filter that needs to be changed monthly. It took my dog a few minutes to figure out what it was and how to use it, but she picked it up quickly. It seems like she's drinking more water now than she did with a regular bowl.
The sound is just a light running stream, my dog has no issues sleeping with it on, it may even remind her of being outdoors. There are a few pieces you need to take apart to clean it, but the trade off is you don't have to clean it as often thanks to the filter. It's on the larger side for a schnauzer, but that just means fewer refills.