Here in New England most people say bubbler. I think that pretty much everywhere else in the entire world people say water fountain...not that those words are particularly interesting. Just thought I would point it out.
Me and n. bicalcarata both live in RI. We must have both been writing at the same time.