Sounds like you want to embed an iframe. If it's just a one off you could use the Static HTML webpart and put the markup in there, e.g.
<iframe width="560" height="315" src="http://www.someexternalsite.com" frameborder="0"></iframe>
If you want it to be more dynamic to show different urls on multiple pages, I'd suggest creating your own custom webpart.