Water pumps for fountains, ponds, water features, hydroponics systems, aquariums, aquaculture systems, greenhouses, gardens, pools, and boat maintenance; apparatus for aerating and agitating water