I haven't used it for an actual tank design but I've used it in the past for making stand plans. The nice thing is there is an extension out there that will give you a list of measurements for your lumber. It is a quick way to turn your design into a bill of materials and blueprint.
I don't think I'd have the patience to design an aquascape in sketchup though.