Bicycle Driven Water Pump/Generator

Hi All -

I'm working on a project that would involve connecting a stationary bike to
a water pump & I'm wondering if anyone out in OBRA-land has created
something similar (generator, water pump etc), I'd like hear about what
components you used, what worked, what didn't etc.

Please reply off list

Thanks

Chris M