Only if you have quite a bit of money. You can buy acrylic aquariums made to order in about any size or shape. They weigh quite a bit less than glass, and a very tall glass aquarium needs very thick glass. If an aquarium is really tall, it may also present some maintenance challenges.
You can walk into an aquarium shop and buy a 125 gallon setup, which is close to the maximum for ready made aquariums. Even empty, a large aquarium is heavy and difficult to move. Add the weight of the substrate and water and you're going to need a really strong floor. If you want to breed fish and have several varieties, a bunch of smaller aquariums may be the way to go. Since you're starting with a clean slate, you could design a really great looking aquarium room with tropical plants and bamboo furniture and all that. The design style of my own aquarium/computer room is called Middle American Chaos.
Congratulations on the new house!