There aren't too many public fountains around here; the one I use is on the town green in Harvard center. It's used by millions of cyclists to re-fill bottles and I never think about it. I also routinely fill bottles in bathroom sinks.
Of course my shocking lack of worry about germs amazes some of my friends. I am basically a clean person who doesn't really think or worrry about germs.