I had some wonderfully quiet nights at Constances place right in the middle of Barcelona. The window in the room is located to a small backyard, so you can even leave the window open at night without being disturbed by the usual nightly noises in Barcelona, such as the rubbish people.
Great place for a few nights in Barcelona, if you basically need a place to sleep.