Where do you get this?

What would be the role of the Arduino in this setup?

I would just use a wireless video transmitter & receiver. If you need to capture the video on the computer you could use a capture card.

If you want an IP-cam I can recommend Axis cams, they are great quality.