Rotherham Council’s leader and the area’s MP has welcomed the government’s announcement that a Manvers hotel will not be used to house asylum seekers in the future.