Hi,
It is good if your Fish aquarium in front of Entrance but you have to check about Fish Aquarium direction and zone.
If you keep your aquarium in North-East that would be good for your house.
I would suggest read this Fish Aquarium Vastu tips and keep your aquarium accordingly.
Thanks