Thanks for the reply iRun,
yes i've left out a lot of pertinent details.
i'd like to grow submerged plants; perhaps grasses, moss on some rocks ferns all grown on a rock strewn substrate. i think most folks may see this project as a loss since one can not easily see (as thru an aquarium) the submerged plant scape. but i think it would be nice just to look down into an aquascape.
i get a huge amount of late afternoon sun through a rather large dinning room window. the indoor house plants have thrived for over a year in this position.
you may be right about the bowl volume. i'll have to fill it to get an accurate measure. maybe more like 10 to 15 gallons.
i wouldn't mind adding some kind of hearty shrimp well after plants are established and the water has balanced/cycled itself. additionally i have a small aquarium heater if it were necessary to keep the water at a certain warm temp. but would rather just have an ambient temp fresh water system.
i will check out the threads on miracle grow organic soil. i am hoping my ehiem 2232 filter will handle all filtration. i can only hope it will accommodate bio filter media. a little unsure at this point how that works i also have a CO2 canister that works by adding sugar i think to a water solution and it lasts for several weeks before needing refilling.
i will mount a - water proof material - circular shelf just above the bowl (bracketed against the two corners of the wall) upon which i can set additional plants, maybe bonsai tree, orchids etc. on the underside of this shelf i will attach some moon lights that make a pleasant and not overpower night light source.
finally, a fountain is not absolute but would be very easy to mount on the shelf i just described. something small low volume, just a trickle of water for an audible effect.
here is my rather haphazard living room fountain.
thanks for your feedback.