If I were building a house, I think I would bite the bullet and essentially build a small swimming pool with at least one acrylic window. Depending on depth, they would be about 4" thick and would weigh a lot. Massive filtration, a thick epoxy coating on the walls and away we go. Need a superstructure over the top for lighting and other services. A way to get in easily and a hooka breathing rig to service the inside. If the money is available, it's a very straight forward project done many times for resorts and other public displays.
Sent from my iPhone using Aquarium Advice