In my case the security camera is also a raspberry pi with the camera module (it could have night vision), connected with a webcam logitech c170 (really cheap) and the motion software to detect movement (https://github.com/Motion-Project).