My girls were slow to drink from it too (my dog was the one that fell in love right from the start, lol), but now even my skittish Willow (the one who would claw you to bits if you so much as walked with her near the fountain when we first got it) will drink from it every now and then. Buffy will as well, but surprisingly, I don't remember ever seeing Molly drinking from it. It's just as well, before she went in an all-wet diet, her favorite pasttime was playing with water and pop and juice and milk, whatever she could find in a glass. She'd drink some of it and splash around the rest, lol
I would just leave everything alone for now. If you ignore it, just walk past it all the time (occationally stopping to fill it up), your kitty will learn from your example. You're not scared of it, so they'll investigate it a little more, try to at least see what it is. Over time, as you continue to be nonchallant about it and the fountain continues to not go about killing everyone, the cat will calm down and decide to drink from it. And once she learns that she doesn't meet a horrible death when she drinks, she'll drink more and more and more. Until she no longer remembers ever being afraid of it, lol