http://www.simplepump.com/
Hand well pumps. Can be motor driven with a small DC motor. Great for wells, they need depth. Pump can supply head pressure but cannot pull water uphill.
http://skipumps.com/
Range of pumps for developing world countries. Hand pumps, foot pumps and so on. Nothing particularly ingenious though and not really applicable to our likely uses.
http://www.mayapedal.org/
A Guatemalan NGO that build all kinds of whacky devices from bicycles including water pumps, blenders, nut shellers, mill / corn threshers. Incredible stuff.