Which ever you use, make sure to follow the recipe and use in moderation because they can make a big difference. Baking soda produces a crispy, thin cookie while baking powder creates a fluffy, soft...
Baking powder generates carbon dioxide bubbles when mixed and again when heated. This is the only thing that makes the dough rise in recipes that don't use yeast.