Are you able to use a database with your web hosting package, such as MySql? Are you able to use a web programing language such as PHP with your web hosting package?

I will have access to MySQL and it should have PHP on it. THe webpage is in HTML though.

And by "podcast CMS", what do you actually mean? What functions/features are you wanting on the site?

It is a church site, and I want to be able to add sermons easily.

You might want to see the video of the talk "Building Church Websites with Drupal" which the hosts of the Geeks and God podcast gave recently. It covers Podcasting/Videocasting your Sermons, and some other topics too.

Podcaster is a an Open Source podcasting sysytem that creates iTunes-compatible podcast feeds. My church used it for two years. It's on SourceForge, it's in PHP.

We just created a video and podcasting CMS platform called MediaCore that we built for a church in Boston. It features full iTunes integration and runs on Python and MYSQL.

You can check out the podcast demo here:
http://getmediacore.com/podcasts

Also there is an administrative control panel where you can control podcasts. You can see the admin demo in action here:
http://getmediacore.com/admin

username: demo
password: demonstration

If you want to see how our client has integrated it you can check out their podcasts here