Short answer, no.
If you want to make noticable power, you will need to fit a turbo or supercharger. You would expect depending on the quality of work for it to range in the vicinity of $10,000-$20,000 for parts and labour.
If you want noise only, with minimal at best power gains, then a CAI is for you.