See this website's background. It's amazing!
How can I create the same effect?
This is simply an overlay done in the browser, not a video effect. You can see the source video here. It simply has a white dot repeated over it in browser using a png that's stored in-line in the CSS.