When you dream of an aquarium it means that it is time for you to stop a little bit, relax, and take time for yourself.  It might be necessary for you to regenerate and deal with your feelings.  An aquarium indicates also a promise of gains, the conditions are set for some kind of material or emotional enrichment.