Hi R.,
There is a cute one called "Too Big for Diapers" about baby Ernie from Sesame Street. I had a few that made the noise of a flushing toilet - but it was a little obnoxious and my boys just liked to push the button, it didn't really get them thinking about and talking about the potty.
We have had a lot of luck with the "Potty Power" DVD. We're going through potty training too - with our second child. The DVD is fun, silly and has little songs and stories that engage the little ones. Plus, when it's time to go potty, it's easy to say the things they say on the DVD and get your little one to follow along cheering "potty power" (really cheesy - but pretty effective!)
Good luck!
--R.