CCTV captures the dramatic moment police overpower a knife-wielding man