Which zoonotic pathogen is responsible for Q fever and is classified as a Category B bioterrorism agent by the CDC?