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.
Useful info on micro hydro including a chart showing head and flow to output power. Very handy.
Lots of info on micro hydro including a book on creating your own systems.