Refers to a tank or facility for keeping aquatic animals and plants. The loanword is widely understood in modern Japanese.
I went to see the aquarium at the aquarium facility over the weekend.
I set up a small aquarium at home and keep tropical fish.