You can buy a small water pump online or in the aquatic section of a big box store and put it in whichever bowl your cat is used to or prefers, so long as the water level is high enough to clear the pump. Most of the pumps have adjustable "speeds" so you can make a big fountain or one that just moves the surface of the water.

That being said, I currently have a ceramic one that I'm enjoying and both my cats seem to like. I used an old pump in it since the pump included wasn't adjustable. Downside of it is that when the water level gets low, it doesn't pump into the upper tray, which can risk leaving your cat without water. But that's a theoretical.

https://smile.amazon.com/gp/aw/d/B08BP96KR6