From historical symbols to heat relief, these charming waterworks are enjoying a renaissance of sorts as spots to cool off in increasingly overheated cities.