As a side note (I dont want to need to make another thread), how can I make a water source that wont freeze over in winter, and is still easily accessible for drinking, without the risk of flooding my fortress
This is how I do it.
Dig a room in the first level underground. This will be your well room.
From the well room, dig a single-tile staircase down to the next level, and obviously one below leading up, that matches. Dig out a reservoir below the well room that matches the size of the well room. Channel a hole in the middle of the well room, for the well.
Dig a tunnel one square out from the reservoir. I make this three tiles wide, but one tile will work.
Dig an upward ramp in the tunnel. This brings the tunnel to the same level as the well room.
Finish digging the tunnel to the water source, stopping just short of breaching it.
If you want to be fancy, at this time install a floodgate at the water-source end of the tunnel and attach it to a lever in the well room.
From aboveground, channel out the tile separating the tunnel from the water source. Either immediately, or after you open your floodgate, the water will run down the tunnel and fill the reservoir.
In real-life, this would flood the well room too, but because of how water flow works in DF it does not happen. However, the floodgate offers a way to be absolutely certain in case the model ever changes.
To construct this requires in total:
1 rope
1 bucket
1 stone block
minimum 1 mechanism (for well)
3 mechanisms for a single floodgate attached to a lever
2 mechanisms per additional floodgate attached to the lever, if your tunnel is wider than one tile