A real furniture maker will tell you that glue (and proper joinery) is the ONLY way to build something to last.Nails, screws, etc. will eventually loosen, although not for years, perhaps.
Oak is prob the strongest hardwood commonly available. Solid oak furniture lasts generations. (We have a 50+ year old school chair that was abused in an elementary school for years & still going strong.)
For an aquarium stand, it really is the design & construction that is important. Wood species doesn't matter all that much, even pine & other softwood will work. But do avoid any particle board construction. That is sure to disintegrate over time. <Note that "oak" stand in a lfs may well be particle board covered with veneer ... sometime not even that .. just plastic coated particle board printed to look like oak.>