Yeah, sounds like a modified aquaponics system. I have been doing reading/research on this for well over a decade. I just don't have the land for it (yet).
Finding the ideal land is tricky, you want some clean flowing water going through it so you can setup one of those little turbines and generate all of your own power, but not be in a place that is prone to flooding, and also have good terrain for growing crops, and hopefully just good weather without having to worry things like tornados or earthquakes.
1000x over man. I have a dream property in mind (fictional) but with the area I want to be in to be closer to family it is out of my range forever probably.
I'll still try to get most of what I want though. Compromises are always necessary.