Old-world, low-rise Muscat is having a glossy makeover, with a host of glamorous new hotels attracting luxury-loving travellers