In a city notorious for expensive rooms, this recently refurbished hotel offers great value with the bonus of a cool bar and restaurant on site.