there is no taking in water issue, and if ur really worried u can get the AEM bypass valve. But in tests I have seen the filter needs to practically be submerged in water for a while for it to suck up detrimental amounts of water, plus most street CAI's dont hang low enough(or the car has a plastic flap below it like ours) so alot of water cant get up there.
For ones I would suggest, injen....I can get a GB price of 218 for 5 or more people but I have heard of deals from 213 to even 202 i think.
Other than that I really like my 40 dollar ebay intake with a raplcement filter, like K&N or HKS, I have a K&N style one that actually has the same material for filter instead of paper but I am lookin at an HKS style right now.
Other than that the ractive intake is almost the same as AEm but alot cheaper, um not sure who else makes em, I know HLS make a long CAI for ours cars that retails for like 5 or 6 hundred but there is one on ebay right now for 200.