One of our all time favourite wallpaper slideshow software used to be Webshots. A number of freewares now let you do the same without having to install any big application. Windows 7 has this functionality inbuilt.
Desktop Slideshow is one such freeware that allows you to change desktop wallpapers automatically. You just set the amount of time you want and then the program will slideshow your pictures as desktop backgrounds.