I have a 40 gallon fishtank in my wall. You all lose.
40 gallons is nothing, I had a 40 gallon tank on my desk prior to me putting a TV there, and my dad has a 200 gallon tank downstairs. Why would you put a hole in your wall for 40 gallons?
Now, 1k gallons would be cool.