Media Web Part is included in Publishing feature, which is only available in SharePoint Server 2010. You won't have it if you're using SharePoint foundation.
If you do have this, activate the publishing feature on your site and you should see it.
Good FAQ here
FAQ
Best of luck,
Shane