For glass check out Globe glass in Edmonton. (don't have the number but they are in the phone book)
i just bought some tempered glass from him and his price was teh best in town.
He mentined that he used to make aquariums but doesn't any more however he woudl be more than willing to provide the glass (he can even bend it for a custom bow front
he can drill holes for overflows and what ever else you need.
Hope this helps