Yeah, that's the basic idea behind both permaculture and aquaponics: Build a tiny ecosystem that can sustain itself with as little input as possible (and like all agriculture, obviously with useful output like food as well).