Free: Oh god no, software like this costs a ton.
Depends, what do you mean by "intro"? Something animated, Special effects or general footage? What you are trying to achieve will affect what software to pick.
However if your limited on budget you wont have that much of a choice in what you pick. Probably look around for open-source video editing software and just do what you can.