The city centre pub is known for its friendly regulars and TikTok karaoke