Hi Bshack,
The beta version of Farm Fountain was a one-gallon fish bowl with a few goldfish in it. Here is a picture.
This has a tiny pump, which brought water up to the top plastic containers with plants, which trickled down, back into the fishbowl. If you want to grow edible fish you'll need a larger tank. I learned from Laura Tiu at the Ohio Center for Aquaculture that the rule of thumb for Tilapia fish is 1 gallon of water can support 1/3 pound of fish. They grow up to be 1.5 pounds.
I hope you can set up a system that fits in your space.
-amy