The cozy bar has hosted visits by the Rolling Stones, U2, Sting and others