An overhaul of Scottish education will see the exams body replaced and “substantial” reforms to the schools agency.