The fountain is a piece of construction that could be of two types, one could be naturally occurring and also be artificial in which the water is pumped into the air so that it looks pleasant to the viewer.

BELLAGIO FOUNTAINS, LAS VEGAS
TREVI FOUNTAIN, ROME
CROWN FOUNTAIN, CHICAGO
BANPO BRIDGE RAINBOW FOUNTAIN, SEOUL
JET D'EAU, GENEVA
MAGIC FOUNTAIN OF MONTJUIC, BARCELONA
PEOPLE'S FRIENDSHIP FOUNTAIN, MOSCOW
KING FAHD'S FOUNTAIN, JEDDAH
FOUNTAIN OF WEALTH, SINGAPORE
DUBAI FOUNTAIN, DUBAI

https://www.stuff.co.nz/travel/news/107604722/worlds-most-famous-fountains