If you are in need of just the software then take a look here
Webcam Software for Video Surveillance and Broadcast
With digiwatcher you can do all that you are requiring,motion, alert, view from phone. They also have a limited use demo to try out.
If you need software and cam with the same features and ability to expand with multiple cams, take a look here
Add to Cart
There are many options out there and most have the ability to detect motion, snap shot area of detection and alert via email or text. After factoring in cost if you decide you just need to "check in on things" without motion alerts etc. most messenger services allow web cam viewing through web, though after just doing it so myself with skype I was only able to get one screen shot with my bb,(maybe someone else has had better luck with others).