It's an OVA series called Carnival Phantasm.

It's a show that brings in characters from the Type-Moon Universe (specifically Fate and Tsukihime) and puts them in wacky situations that make fun of their series and characters.

I finished it recently, found it very enjoyable and would recommend it to people that like Fate.

And it has both excellent opening and closing music!