If the container is "food safe", and not receiving sun light, then quite a long time!
Can freshwater go stale? Never heard of that. As long as you have a lid on it so nothing can fall or float in Id say it would be good for an indefinite amount of time.