Going with what you're asking about, maybe something like this to interface with remote viewing? http://www.eyefi.com/products
Honestly, an IP camera setup will probably best suit your needs. Something like this: http://www.bestbuy.com/site/netgear-...&skuId=1668003 This one sends notifications and a live stream when there is motion