Water fountain - Found in a park, square, garden, or in front of a building, etc. Used for decoration.

Drinking fountain - For the purpose of drinking water.

Bubbler - Midwestern term (mainly Wisconsin) for drinking fountain.