This gloriously revamped palace with a colourful past is the smartest new place to stay in the Pink City