I'm in the process of planning a 160" long by 100" wide fish room on the back of my wrap-a-around deck on the second floor of my house. The deck is completely open below so adding support will not be an issue. After the room is built I plan on doing an in-wall tank off my dining room. My main concern right now is weight bearing since this is going to my dream setup which means display tank, sump, frag tank, refugium, quarantine, the whole nine yards. The deck is currently lag bolted every 16" into the house wall that the display tank will sit flush against. The joists run perpendicular to the tank and wall and are every 16" as well. The back of the deck is supported by 6X6 posts off each corner but don't have any underground footings so I am fully aware I will have to add multiple support posts and beams in various places below the fish room to support the weight.
The display tank will be just under 400G: 84L X 36W X 30H. On the back corner of the fish room will be a 3 foot high wrap-a-around bench. The part of the bench bordering the back wall will have a 100G refugium as well as 2 55G mixing drums below the bench sitting on the deck floor. The part of the bench bordering the wall on the right side of the fish room will have another 100G frag tank on top. Below the bench on this wall will be a 120G sump sitting on the deck floor.
I do realize that this is a little crazy but I think any of us that are in this hobby are a little crazy so really I'm just following suit

I've owned this house for four years already and don't plan on leaving anytime soon. I got engaged a few months ago and we're planning our wedding ceremony on our property so this is a little bit of an engagement present for us both too since she also loves the hobby
I'd love to speak to someone with any kind of engineering background that could lend some kind of assistance with the build. I can call you anytime that's convenient for you or email works well too. Any suggestions would be greatly appreciated. Thank you.