I'd recommend the pump from harbor freight. If you attach the water bucket type thing then you can water pump safely. Buy it here:
Harbor Freight Tools - Quality Tools at the Lowest Prices
Also, you can either make your own pump or buy one. I'm in the process of making my own right now:
1 aquarium gravel vacuum cleaning tube 10x2 which is $11
1 can of plastidip which is like $5
So you can have a complete working pumping set up for $11 + $5 + $25 at the most for shipping of that pump (unless you buy it at a Harbor Freight store, which it'll be $17) = less than $50.
Or you can go to sites like lapdist or vacutech or pumptoys and buy a
cylinder for $90+, with a pump $135+ (which ISN'T water compatible!).
Water pumping definitely is the shizknit.