Cats and dogs drink more from moving water. Consumer Reports tested pet fountains on noise, ease of assembly, and pet appeal to find the best ones