If you're going to use it for potable water, I'd get one that is made from NSF listed materials. You might want to consider the pressure rating a hose has, especially if you plan to have a regulator at the city water inlet (as opposed to at the faucet). Some hose materials can sometimes impart an offensive taste to the water and some can be bothered more than others by this.
I seem to recall seeing a collapsing type hose somewhere in the past year that was NSF listed and had a good pressure rating. I think it was at an industrial hose supplier. Maybe one of those type of suppliers may have something that will work.