A Wigan hotel that was home to asylum-seekers for eight years has re-launched to paying guests after a major makeover.