No, Xbox Live Gold is not required to play Crackdown 3's single-player campaign. You can explore the city, fight gangs, and complete missions entirely offline.
However: An Xbox Live Gold subscription is required for multiplayer modes.
Enjoy the solo experience without an internet connection!