I'm assuming that you're looking to mimic an ecosphere/biosphere/what have you with your tank, in that it's a "set and forget" system with no additions of food, or removals via water changes. You would have to add water to counter evaporation. You might also need to dose nutrients for the macros to take up as well, so the herbivores of the system could eat it, and in turn be consumed by omnivores/carnivores of the system (in this case, your fish). In this case, you may not want to use a protein skimmer, in order to keep element balance (N, P, K, etc.) within the tank.
You'd probably also want to mirror your fish to reflect this. Probably a surface film grazer like an Ecsenius blenny, a sand sifting small fish like a Valencienna or Signigobius, and a podivore like a possum wrasse. Perhaps a CUC eater like a puffer once the CUC snails started reproducing enough. The smaller the better, and the more likely you are to succeed. You would probably also need to figure out how to keep the macros in check, as the typical grazers (tangs) would get too big for the system to provide for it.