John Lloyd says the work of security agencies can jar with the values if democracy but in this time of threat, security and intelligence agencies are vital