There are several sections where you can add a video player to your Campaign Site. When adding a video, you can simply copy and past the url for your video.
Editor video placements can accept Youtube and Vimeo urls.
Add videos to
It's also possible to embed a video into a Campaign Site body section. You'll need to use the HTML editor to embed a video player. Learn more at the developer documentation.