Metacafe, the Israel-based video Web site, is moving its headquarters to the Bay Area, increasingly a magnet to new Internet entertainment sites that rely on content created by the masses.