Answer: There are no two consultants that will tell you the same thing regarding the answer to your question. In my opinion the "unseen" energy (based on exact compass degrees) dictates where water is required inside a home. For example, in a "reversed" house you would want to place an aquarium as close to the back of the house as possible, provided the gua area did not call for FIRE as a remedy.
Regardless what kind of house you occupy, I would avoid placing a large body of water (big fish tank over 25 gallons) in bedrooms, bathrooms and kitchens. Also, the facing direction is not as important as location. WATER located in the SW and East gua areas of a home or property is auspicious for the accumulation of money and wealth through 2023!