Maybe of interest to you, Shedd's Aquarium in Chicago had an aquarium biotope (is that the right word?) set up with a river, land trees, fish, I think even frogs or turtles...the fascinating thing is that it was (almost) completely self sustaining...but still at times needed some intervention...