I’ve been told that water fountains are hard to clean and not hygienic. I don’t know how true this is.
My cat loves playing with water she has a small paddling pool in the bath which I put a few plastic cat toys in, she enjoys fishing them out she licks her paws as well as drinking the water which I change twice a day. She also has a small bowl of water in the bottom of the shower, her favourite place to drink. We remove the bowl when we shower. There’s another bowl next to her dry food in the kitchen which she rarely drinks.
She loves a dripping tap, she puts her paws in the drips then licks her paws, she’ll wait for you to turn a tap on, she drinks a lot of water throughout the day.