The concept is interesting, but practice tends to be very different from theory. I’d love to have suitable water on my land but I’m in the wrong part of the world. I believe that you actually need a very large volume of water or a very long fall to get much power out of it so the chances of finding a suitable property are slim.

I’d say that although you’re heart is in the right place, you should be a bit more flexible in your thinking.

Finding (a) suitable partner(s) is a major challenge anyway. I’ve been living off-grid on my own for many years – still not found anybody who I can get on well enough with to share my dream. Sad but true, that’s the way it is today. Everyone is too different and too unwilling to compromise. – or put in the work that is needed for this sort of lifestyle.

I wish you luck with your dream anyway :)