Yes I agree. I actually believe that there are places that use the system you mentioned - with fish living in indoor ponds. The fish waste adds nutrients to the water which gets cycled back to the plants. Its like a self sustaining ecosystem.
Yeah - self sustaining cities! I look forward to the day they become a reality