jason noble has a new web part out...a slideshow web part that lets you view items from galleries on your site and galleries form other sites as well...you should check it out.
UPDATE: A reader points out that unfortunately these links are no longer valid. I do not know where to obtain this web part, but you may want to look at some of the Silverlight-based slide shows that may be able to integrate into Sharepoint.