A government advisor will be brought in after a damning report on a council's children's services department.