Very good question sir. I have asked the same in the past.

Apparently an ECU tune will NOT cause a smog inspection failure.
Needswings intake WILL FAIL because it doesnt have some BS carb certification, so you have to take it apart and put the stock intake back on for smog inspection.

That is unless you can find a shop that would... ahem... ignore the fact you have a non certified intake on there.