Mobiscope Video from Webcams 2.6.140
the author of this app says:
Video from webcams on mobile - for home surveillance or just for fun! Watch real time webcam video stream on your mobile; get motion detection alerts over email; any web/IP cam support.
Note: BlackBerry Storm. See Home Page for other mobile device compatible versions.