I'm looking to create an intro video to place on my site's homepage similar to this, but I'm not really sure where to start:

Is this something simple enough to do on my own or am I better off just hiring someone to do it?

If it's simple enough to learn, can anyone recommend some quality software to use and/or possibly point me to a good beginners tutorial?

If I'm better off hiring a professional, I would need someone local to come in and shoot the video, so I would probably hire via Craiglist (unless someone can recommend a better route). What's the professional title of someone who does these (Videographer, Video Graphic Guy, etc)?

Thanks in advance.