You do not need an Xbox Live subscription to play the single-player campaign of Skate 3. You can enjoy the full story mode completely offline.
However, an active Xbox Live Gold subscription is required for the following online features:
In summary, if you only want the single-player experience, you can play offline. For the complete experience—including multiplayer, community creations, and DLC—you will need Xbox Live Gold.