Can hydroelectricity be used in peoples homes right now?

It can and is. In my country (Faroe Islands) , whole villages are being powered by hydroelectricity.

I've never heard of a house having a private generator, though, if that's what you're asking.