You do not need an active Xbox Live Gold subscription to access downloaded DLC, but you do need an Xbox Live account (free Silver tier) to:
You can also transfer DLC via disc or from another Xbox 360, but you must own the DLC first.