Cashel Palace Hotel opens its magnificent doors