Foundation forum member ‘dozencrows’ has modified the ‘Motion’ software used for motion detection for the Raspberry Pi camera module. I’ve tried it myself and it works brilliantly and with only a couple of seconds lag.

Instructions on available on the Raspberry Pi Foundation Forum. If you have problems running it, read the rest of the thread as many of the common issues are covered there.