Downloading videos from dnatube.com
Two popular apps are TubeMate (as zamin suggested) and VidMate. They can download videos from all popular video hosting websites. You won't find them in Play Store due to some copyright issues. Sites like YouTube, DailyMotion, Youku etc are provided as speed dials so you have to manually enter dnatube.com  in address bar. Comment if not working.