A new school for youngsters with additional needs has opened its doors after a multi-million pound redevelopment project.