Creating a "Cover Page" with embeddable code

You should be able to accomplish what you want. Go to Pages. Click on your cover page. Then click on Video. Click on the </> symbol. Enter your embeded code in the dialog. I've added some pics below to hopefully guide you.

You can use a regular page and then hide its header and footer using css. 

You need to know the page's collection ID. You can find it by Inspecting the page code and looking at the BODY tag. 

Then insert the collection id after the # in the code below and paste it into your custom css after any other code that may already be there. 

#collection-id-goes-here {
  header.Header, footer.Footer {
      display: none !important;
  }
}

Okay..damn this is one of those issues that I wished I had wordpress so I could just put in the code easily. But none the less, I did this on https://crystalopedia.com and it went pretty well. 
I did this using colin.irwin's suggestion and it works pretty well. Highly recommend it