This is the one we use, it's funny what cats will decide is strange and scary and what they love, isn't it? I agree that the one they will drink from is the one that's best.

I know you said no plastic, but the catit brand water fountain with the little daisy in the middle has been a favorite of my 4 cats for going on 5 years now. You can run all the parts but the pump through the dishwasher, and replacement pumps are under $10 on amazon, I have ordered one every 2 years or so. I tried a few different nicer looking ceramic or glass bowls with a pump but they really like the choice between the flat surface of the fountain and the little streams of water running off the flower petals, so that's what I went back to.