From my limited experience with a glacier/tundra fortress...
Water will show up to build with on certain menues, but you cannot move it to any stockpiles. This is inconvenient, to say the least. I haven't actually tried using it, however, as I skirted southward another biome and bypassed a local aquifer that way.
Check those layers! Some glaciers come with a aquifer, some don't. There is a trick dependent on freezing to bypass the aquifer, but it requires some materials.
I've gone back to a glacier map... Here's what I've seen:
For fun, watch your new stairs upward melt... some of them survive, but it makes reaching the stone a pain. You can build a mason's workshop out of 'water'. As well as a butchery, which will be quite helpful when all your mules bleed to death.
Ooh, there are zombie polar bears and sasquatch. In addition to the above deaths, another reason to set up a meeting hall ASAP. Without hatches, you may need to channel yourself a defense in the ice.
Ice behaves pretty much like peat or silty clay did when I could order it from the embark screen. No growing in it, though. But it does mean you _can_ get a trade depot up even if you do run out of stone/wood.
You cannot craft water... Though you can build walls and floor out of it, handy if you're short of material, especially for that trick of getting past an aquifer.
So... for a real challenge, take no aquifer, no soil, just ice and stone. No way to grow crops either.
So you need either and aquifer or soil to survive.
You can smooth ice, and probably engrave it as well.
You can pave the featureless ice with an ice road...
There is unfortunately nothing very interesting about pure glacier... its an unending sameness. I recommend mixing with other terrain for variety's sake, if nothing else.