White Vinegar or lemon juice can work and a non metalic scouring sponge.. However often with hard water stains the glass becomes etched. Once that happens nothing will clean it.
My shower had a similar problem, the glass needed to be replaced, to look crystal clear again.
Google hard water stain removal. There are a plethora of articles out there.
hope this helps.
A couple of planted tanks