UPDATE:
I have overhauled the design in a few ways: (see pic below)
-Opted to have the turtle area above the main tank to remove the wasted space and increasing the water volume to the full 670 gal
-Removed the waterfall incase I decide to put a CO2 system (thanks fishguy306)
Now it's down to the more fine tuning points, hopefully some of you can help me with this again
When i was drawing this up I stacked 2 2x4s along the bottom to be screwed into the plywood base to make a lip for the glass to be push against by the water and to make additional sealing surface using silicone. Since the force will be horizontal and equally distributed across the whole lip all that stress would be sheer stress on the screws & glue holding the 2x4s to the plywood, not the wood itself, so should i not be able to get away with 2x2s? this would allow for another 4 inches in width in my tank!
Also do i actually need to stack 2 2x4s (or 2x2s) to make 3" of sealing surface in addition to the 3/4" where the glass sits on the base? I figure i should be able to get away with just one (1.5").
Once i get these questions answered and my design updated i can start planning out plumbing! Already got 2 pages of notes typed out lol
Thanks everyone on their input!
Side note: I got the glass and the metal stand priced out: 19mm glass is $29 CAD/sq. ft (1.5" acrylic was almost double) and a custom metal base made from plain steel unpainted will run me 300-350. so whole thing will run me 4.5-5k I'm thinking.