This DC 3-6 V Mini Micro Submersible Water Pump is a low cost, small size Submersible Pump Motor which can be operated from a 2.5 ~ 6V power supply. It can take up to 120 liters per hour with a very low current consumption of 220mA. Just connect tube pipe to the motor outlet, submerge it in water and power it.
Make sure that the water level is always higher than the motor. The dry run may damage the motor due to heating and it will also produce noise.