Option 1: Paid Module
I have had great success with a module called Promo Banner Slider on Magento Connect made by a company called Involic. Many large Magento stores are using this for their home page hero graphics.
At $39.99 it's fairly inexpensive.
On Magento Connect:
http://www.magentocommerce.com/magento-connect/promo-banner-slider-carousel-promoslider.html
Direct Link
http://involic.com/magento-extensions/magento-promo-slider.html
To add to any page, add the widget in the CMS.
Option 2: DIY
If you want to DIY this, you can easily use the carousel from Twitter Bootstrap -
http://twitter.github.io/bootstrap/javascript.html#carousel
Here's a tutorial on how to roll it into a page:
http://webdesign.tutsplus.com/tutorials/htmlcss-tutorials/twitter-bootstrap-101-the-carousel/
To add to any page, use the above tutorial to add the correct markup to the page in the CMS that you desire to display the images on.