Think open mics, boutique shopping and furry companions — these cafes are turning everyday hangouts into immersive escapes