Water weighs somewhere around 8.5lbs/gal, so a 100gal tank would weigh 850lbs with just the water ( not including the tank itself ).
I am no engineer but from my understanding, as far as the rock and sand goes, it wont reduce your weight, it ADDS to it since the rock and sand have a higher...