Human guards would be more effective than the drone at stopping an active shooter; but they won’t stop active shooters from being active in the first place.

For that you need to attack the actual problems.