Aberdeen pub closes its doors for the last time