On that page, this is done using a Jquery plugin named 'Tubular'
Tubular is a jQuery plugin that lets you set a YouTube video as your page background. Just attach it to your page wrapper element, set some options, and you're on your way.
This is the official page http://www.seanmccambridge.com/tubular/
and is free for use.