Yes, my cats have loved fountains. You can make one for cheap. Large glass jar, aquarium filter pump, rubber band or something to hold the pump against the jar, and some decorative glass rocks in the bottom to keep it in place
*fresh, running water that is not right next to their food. Cats would normally eat… dead things— and as water literally right next to these generally is not exactly hygienic, they will (as an evolutionary fact) much prefer even random puddle water.