Ever since 1999 when i bought a Audi Quattro i've only ever used AWD cars, and i have no intention of ever having FWD again, i moved from RWD in the 80's and would never consider a RWD car again.
In snow which i assume Scotland may see some, FWD beats RWD for me having used both in snow, but AWD leaves both behind.
Fit winter tyres or all season tyres as a compromise and you will get through most snow the UK sees.
The CX-5 AWD is generally highly thought of but there are better systems available.
I've had to use a CX-5 in 4 inches of snow a couple of years ago to rush the wife to hospital, delays of upto an hour for the ambulance to arrive at the time.
I passed a car in a ditch and numerous others just abandoned on the road side, but managed the 25 mile round trip with out drama, in fact on summer tyres i was impressed.
AWD is also an advantage on wet roads etc, its downside is extra weight, around a 3mpg fuel penalty, and increased VED. Buy the 175ps.