Aloha VMarra,

A bubbling fountain is the common fountain you finding in most stores, that pushes water up, and recirculates it.

If it is to go in the north, you could look for one made out of metal which enhances the water element.

Much Love, Shawn