The Nikon D3100 is a great option, its and entry level dSLR and would give absolutely stunning shots and videos alike. Its features include the following:
--14.2-megapixel DX-format CMOS image sensor,
--3-inch monitor with One-Touch Live View shooting and movie capture,
--Includes 3x 18-55mm Zoom-NIKKOR VR Image Stabilization lens,
--Full 1080p HD Cinematic Video with full-time autofocus and sound,
--Easy-To-Use Nikon Guide Mode with intuitive controls and on-board assistance,
--Capture images to SD/SDHC/SDXC memory cards (you'll have to buy it separately, its not included with the camera and lens).
Read this review to aid in your decision:
http://www.amazon.com/review/R3NZH2Q4KNDSWK/ref=cm_cr_pr_perm?ie=UTF8&ASIN=B003ZYF3LO&nodeID=&linkCode=&sourceid=md.ds&tag=famaeim-20
And you can look for a good discount here:
http://www.amazon.com/Nikon-D3100-Digital-18-55mm-3-5-5-6/dp/B003ZYF3LO/ref=cm_rdp_product&sourceid=md.ds&tag=famaeim-20
I'd also suggest that you look at the Nikon D5100 which is one step ahead of the D3100 and has more features, take a look:
http://www.amazon.com/Nikon-D5100-Digital-18-55mm-3-5-5-6/dp/B004V4IWKG/ref=sr_1_1?s=electronics&ie=UTF8&qid=1323588132&sr=1-1&sourceid=md.ds&tag=famaeim-20
Both are great, get the one that fits the bill.