Usually it's "Holy Spirit" because it a name. But, on the other hand, it might be "holy spirit" if you aren't actually referring to the third member of the Christian Trinity, but some generic spirit that happens to be holy? How's that for and English major? LOL!
AJ