I have a 33 gallon clear sterilite container that at the base is 1 inch of clay soil and sand mixed with 2 inches of road gravel, capped with 1 inch of
pea gravel, and 1/4 in of sand. I have the container between the windowsill and a piece of furniture so the two main sides don't bow out when filled with
water. Also, when filling the water, you would cover it with a large garbage bag and fill slowly and very slowly remove the bag until the soil gets processed or it will stir up dirt, and also fill slowly.
So the base of road gravel (1/2"-1" lowe's brown gravel) looks like a gravel bed and clay soil mixed in because it holds together better.
The container holds water, and the lid of the container is under it, so the rim points up, and the lid holds a small amount of water under the weight of the container.
The water in the main container would go bad unless you had an aquarium bubbler, but I use a syringe or turkey baster to suck the moldy water that's in the upside down lid that's under the 33 gallon container, and release it in the33 gallon container. The moldy water "treats" the water naturally and how nature works in that water travelling towards a
pond pushes grass and leaves down, which grow mold under it and treats the
pond naturally.
I have a minnow in it, and I drink out of the container and it's good, but if you were to keep fish and drink out of it, you'd have to make your own food from unsalted or from the butcher and not frozen catfish. I make my own gel food with knox gelatine. Also, adding water from the main container to put in the moldy water in the lid under the weight of the container at the bottom also keeps the mold in check but it's an experiment to see how much moldy water to put in the 33 gallon container above(not too much, but you can taste, but if you don't use the moldy water you can get a churning stomach from bacteria). Also I use rainwater in the container left out in the sun for a day to gas off pollution before putting in the container. Also you can plant certain grasses or lilies if near a window or if you have a light such as a chinese box light, but my chinese box light is 2 1/2 feet above it so as not to heat the water, and I use it at very low power.