It shouldn't ever go stagnant, Shep!
Those water tanks are all enclosed, so light and mozzies cant get in. We never had any trouble with ours. Those large tanks you see on farm houses etc, are probably scores of years old and never flushed out!!
You can always flush it out say once a year (on a rainy day
) to make sure.