Does Nerf Herder sing the theme song for 'My Babysitter's a Vampire'?

No but they did do the theme for Buffy The Vampire Slayer. Apparently the song you are thinking of is by a band called Hathaway Brown and they were formerly known as Copperpot. Never heard of them by either name nor have I ever seen the show but there you go.