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.
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.
A Guatemalan NGO that build all kinds of whacky devices from bicycles including water pumps, blenders, nut shellers, mill / corn threshers. Incredible stuff.