Aberdeen bar reopens its doors to the public