@JollyHockeyStick That totally depends on where you are in Aberdeen City though! E.g. Torry =/= Cults. 
scottswede, I am foreigner living in Scotland. If you move to one of the cities, you'll probably find there are a lot more family-oriented resources available to you than there would be in the tiny villages. However, the cities (IME only) tend to be very, very stratified. For instance, Glasgow and Aberdeen are both cities where two neighborhoods - located right next to each other - can have completely different house prices, family income levels, social issues, expectations and local school performance. If you have any contacts in Scotland, definitely ask them for advice on which neighborhoods to look for housing in.
If you are looking at Aberdeen City, keep in mind that it has some of the best and worst performing high schools in Scotland within its district, in terms of Higher exam pass rates anyway (exams which are required for university entrance). East Renfrewshire, which is on the west coast closer to Glasgow, is a district that seems to have a consistent reputation for the country's best Higher exam pass rates. But, there's more to a school than exams alone - there are opportunities for achievement outwith academics, there is behavior management, there's a lot to consider. Scotland is also moving towards a new national curriculum: CfE, which several schools are currently adjusting to.
If you need to make a decision soon, your best bet is to have a look at the high schools, see which ones appeal to you the most, and then look up their HMIE reports. From there, you should be able to find information on those schools' feeder primaries. When you finally select a few primaries, start asking the staff a lot of questions. My stepdaughter's primary has some lovely teachers, but has lately been acting as though it's beneath them to communicate with parents - e.g. my DH and I found out from the child herself last winter (age 5 at the time) that DSD gets no music lessons whatsoever anymore due to budget cuts. Keep in mind, if you expect specialist teachers to give your kids music, art and gym class, with a chance to join a school team or the kids' orchestra, you may need to go private. :-/