aberdeen is good,nice choice of pubs/clubs/resteraunts and plenty things to do
out by the airport is a bit quiet but only a ten min bus/taxi ride from town centre (taxis are fuckin expensive tho

)
out by the airport (i assume you mean dyce) has quite a few b&bs and is a nice enuff area