Sophie loves a flushing toilet. She is the only cat I have know that you call by opening the back door and flushing the toilet. She leaps up onto the seat and tries to bet the water.
We had a decorative fountain that the cats liked, but it was a gift and the giver was upset that the cats were using it. We had put it down on the floor at cat level. We bought one of the Pet ones, but it was really bulky took up too much room, so we got rid of it.