Paul,
If you are from the UK, you'll find Aberdeen pretty much like any city. The same stuff here as you'd get anywhere. Its a bit grey to look at but as someone said, the weather isn't actually that bad but it never gets that hot.
Schools are generally very good and the ASPC as mentioned above is the best source of info for property. Property market has remained very strong due to all the oil execs and the demand for family housing. Scotland have this 'offers over' system, so a house up for sale for Offers Over £200k may well go for £320k - You can't say, but recently houses have often been going for 50% or more over the asking price, but I dare say that'll calm down a bit during these uncertain times.
Regarding the working roster, your time off is yours. All the 3 big companies up here are a bit short (!) so ask if you would come in on your time off, but its entirely up to you - There's no 3 line whip. The 7/7 roster is the only one that really allows you to get away and live elsewhere and there are a few pilots that do that. Otherwise Bristow have a base in Scatsta (Shetland Islands) that operate a 14/14 roster which allows you to live even further afield than the UK.
If you're asking about schools, I'm guessing you're a family man, or planning to be and whilst Aberdeenshire may seem a bit remote, there aren't many better places in the UK to bring up a family.
Good luck