Without knowing what service or provider you are using for the streaming it would be difficult to suggest a camcorder that would work.
In general any camcorder with a Firewire (IEEE 1394) port and a compatible port on your computer should allow the streaming function.
It might also be possible to use any camcorder and a digital bridge..such as the Dazzle from Pinnacle.

If they are VHS-C (compact) tapes and you do not have a working camera to play back on, you will first need a converter cassette to be able to play them on a full size VHS player.
http://www.bestbuy.com/site/Dynex%26%23174%3B+-+VHS-C+Cassette+Adapter/6997146.p?id=1099392073837&skuId=6997146&st=VHS-C&cp=1&lp=1
Next...if you have a stand alone DvD Recorder you can connect using the A/V (Audio Video) cables and connect the output of the VHS Player to the input of the DvD Recorder and copy the footage to a DvD.

A D-SLR with a Macro lens will give you the best results. The Macro lens would have to be purchased separately. Some cameras like Olympus will sometimes include a Macro as a 2 lens Kit option.
There are many compact cameras that have a Macro setting but to get close enough to your subject with a compact usually cast a shadow across it making the shot difficult.

There is a housing available for the DSC-W220 and many other models.
You might want to look at a Camcorder as an option. BestBuy has a underwater housing for Sony Camcorder found here:
http://www.bestbuy.com/site/olspage.jsp?skuId=7688601&st=underwater+housing&lp=4&type=product&cp=1&id=1138083309328

There is a list of compatible camcorders listed. That way you'll get video and photos.