A water cooler is a machine that cools and dispenses water, which are are connected to a water supply. A basic type of cooler has an inbuilt chiller (refrigeration system).
A drinking fountain, is a cooler that holds a small tank with chilled water that is instantaneously ready for dispensing cooled water. This type of cooler has a separate & remote chiller (refrigeration system).