Whether you need Xbox Live Gold for DLC depends entirely on the content type and game design.
Rule of Thumb: Single-player + DLC = No Gold needed. Multiplayer/online-dependent DLC = Gold required. When in doubt, check the store page.