So far, I've just been purchasing the aquariums I need at the best price I can find. So, it's all been the normal green glass. If (when ) I get the large display tank I want, I'll use the best glass I can find. It will most likely be a DIY to fit in a custom corner in our newly finished basement.
Also, I think the idea of a 'coffe table aquarium' is awsome. Not practical for me (two small kids), but would still be a great focal point.