A decent fountain throws water up into the air to refract sunlight and cool the surroundings, writes Terry Prone