This ancient Scottish tavern was a raucous, cross-generational hangout where everyone – young and old, locals and tourists – sang themselves hoarse to Fairytale of New York