I know of some cities on our west coast, where the tap water is extremely low in tds. I suppose one could use it for certain tanks or even reefs, with some filtering.
As others mentioned, most are not like that. Even in our own city here, the newer section has a tds reading of 200 to 300...