Asylum-seekers will not return to the Rotherham hotel where a riot broke out over the summer, the Government has confirmed after months of uncertainty.