Available on the Xbox Marketplace. Maybe the PS Store too, I haven't turned on my PS3 in a while. And I'm sure also available on every single videogame website out there.
Granted, the video itself is heavily scripted. Chances are it is also running on high-end PC hardware and the console versions won't look that good. And given its scripted nature, the game's actual gameplay won't flow anywhere near as seamless and impressive as that video.
But again. Wow.