There are many video modules on SC but, last time I looked, very few allowed video streaming from a live source.
Most simply do "progressive download" which is not the same thing at all.
To stream live video you can use Windows Media Encoder to take the output from the camera and turn it into a stream-able format. It does this in real time.
WME's output is streamed out to "the web" using Windows Media server.
You then need a compatible player / viewer.
Be aware that many hosting companies do not like / allow WMS server as it opens up some security issues and supporting the service can be time consuming (they say).
A friends (dnn) website provides live WildLife Cams
http://www.newforestgateway.org/Wildcam/LiveCameras/tabid/117/Default.aspx
I helped a bit with this and we ended up using the Open Video Player
http://openvideoplayer.sourceforge.net/ as this can stream and provides a flash and a silverlight interface. This is not a DNN module but it works fine in a HTML module.
A decent article on how to set up a live webcam feed is here.
http://www.robertwisbey.com/how_to_web_cam_wme.html
In this example WME doe the job of pushing the content to the web. No WMS involved.
I have not followed these instructions but they look OK. In this case the player code would be in a standard Text/Html module or, if it does not work, put it in a page of html and open this inside an IFrame.
Hope this helps.
Good luck