Why would a water fountain pump make a lot of noise before it is submerged in water?
The magnet rotates with the incoming mains frequency .When there is no water there is no lubrication of the plastic coated magnet and the plastic housing .Water is a good lubricant for plastic parts .Also the water muffles some of the remaining sound .