structural advise

Hello, So I've upgraded my personal "aquarium" from a one bedroom condo, to a 5 bedroom house (+ additional rooms that are not bedrooms). I've always knew my tank is too small and my partner encouraged me with ideas of crazy stuff like, integrating a fishtank in the wall, etc. While what I want...