I also have a fountain for my cats. It really is amazing how much more they drink when the water is moving.
I, too, was afraid that my cat would be afraid of it. My thinking was, if he gets splashed one time, that's it and he'll never use it again. So, I did some research and found one made by Petmate called Fresh Flow Fountain. It actually has a ramp that the water runs down so it won't splash the kitty. I placed his old bowl near the fountain and was gradually, over several days time, moving it closer when I realized he was only drinking from the fountain. He really liked it and adjusted to it better than I thought he would.
I now have 3 kitties all using the fountain. So I upgraded and got the larger one and only have to fill the built-in reservoir about every 5-6 days or so. I gave my smaller one to my veterinary office and my vet commented on a later visit that this fountain was much easier to clean than hers at home and that all the clinic kitties really liked it.
It comes apart so easy for cleaning. Just a minute or two with a toothbrush and water and it's all clean again. The filters that go in the top keep it really pretty clean and only need changing about once a month or so depending on how many kitties are using it. It's silent unless low on water and very compact with everything built right in. It also has a control lever so you can adjust how fast it flow according to the kitty's preference.
I've provided a link below to take you right to the fountains so you don't have to search for them, but if you have any problem with the links, you can always look for them on the Petsmart website. I hope your kitties like it as well as mine.
Smaller Fountain:
http://service.bfast.com/bfast/click?bf ... =hardgoods
Larger Fountain:
http://service.bfast.com/bfast/click?bf ... =hardgoods