Why only enjoy the tank while in the dining area? Why not also enjoy it while in the bedroom? Sounds like a PERFECT setup for an in-wall setup. Run your overflows off of each end, enclose the ends with nice cabinets.
I see an absolutely gorgeous setup in your future.
pssstttttt.... go for it, she won't notice...