We need to keep our children safe, so CCTV is something that would be beneficial in achieving the goal of safety for them. The one condition that I would have is that it is not abused by those who have access to it, and that students, teachers, and other school personnel don't have their privacy infringed upon.
Some people might ask, "how can this be done?, or "we need to make sure that the students and other school faculty are safe." This can be done by better screening the people who are employed, and partnering with everyone involved in a student's education to ensure that any student is physically and psychologically healthy. This can cut down on the # of violent and non-violent attacks by other students.