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.backwoodssolar.com/catalog/hydropower.htm
Useful info on micro hydro including a chart showing head and flow to output power. Very handy.
http://www.microhydropower.net/
Lots of info on micro hydro including a book on creating your own systems.