The free Titan Downloader app features a built-in Web browser that lets you save video files you find on various sites for playback at a later time. You can queue up multiple videos to play one after another and set a pass-code lock to prevent others from accessing your collection.
Titan Downloader in the iTunes App Store
See also: MyMedia, iDownloader