The movie is You, Me and Dupree (2006).
Owen Wilson plays Dupree, the chaotic, overstaying houseguest of newlyweds Matt Dillon and Kate Hudson.