for one, you're not going to feel your vtec kick whether or not you have an auto or 5 speed, it's a sohc. some say they do, but either way it's nothing that'll blow your mind or will throw you against the back of your seat. secondly, vtec engages around 5.5 rpm, the only thing you'll notice is that it starts to get much louder. thirdly, if that's the only reason why you're switching, dont even bother. it's already a waste of money to do it in the first place, that is unless you have pockets full of money and could care less about where you blow your money.
you're also not going to need a bypass valve unless you like to drive through some deep puddles, but you can if you just want to be on the safe side. just about any intake will do, although there little issues here an there.
my last bit of advice, dont be lazy and do a search. most likely anything you wanna know about has already been posted somewhere.