The first question one should ask is whether one can reasonably expect to make back the energy embodied in the generator. For example, strapping a generator to a stationary bicycle is unlikely to reach this point. Small scale wind turbines have a similar problem [1].

I really doubt that generators in individual houses drain pipes would be viable.

[1] http://theoildrum.com/node/6954