We stayed in Hotel Colon. Great location overlooking the Cathedral. You'd want a room facing Cathedral and on a higher floor to avoid street noise. While you're looking, make an online reservation and tour of Sagrada Familia.
We stayed in the Hotel Moderno on Las Ramblas. I don't recommend that hotel, it's really old and in need of some TLC but I highly recommend staying in that area.