Most of the people find that Photo Stand Pro for iPad is an amazing and quite interesting app which shows pictures from your photo library by just running the application when your iPad is not in use. And in Updated Version 1.1 you will find different features like orientation, hidden status bar in slide show to give full "Digital Picture Frame" effect.

iTunes Link : Photo Stand Pro for iPad for iPad on the iTunes App Store