Do I need a cat water fountain?

I have two adult cats and I’ve been considering getting a water fountain for them but r they necessary or better than just a plain water bowl? My cats only eat wet food so they don’t have a problem with dehydration. We also have a small dog so would that cause problems? And can anyone who has switched from a bowl to a fountain give their testimony cause I’m worried my cats would hate it. Plz help