Be careful to not hit any big puddles or your "custom" CAI will pull up water and kill your engine.
Not very likely, and here's why:
1. The location of the opening is in front of the tire, and appears to have a little bit of a guard built onto the front of it to keep water away.
2. This is an air "scoop", not an enclosed tube. There is probably very little actual suction down near that opening; it's designed more to catch air and redirect it up into the airbox while the truck is moving. Any water that did hit it would probably drain back down off of it before making it into the airbox.
3. Being that there probably isn't any suction, I don't think much water would stand a chance of getting pulled in; think about the path it would have to take. It would have to make it up the scoop, into the airbox, onto the filter and then through the element, into the primary tube, and into the intake manifold. Personally I don't think much water would make it past the filter, if it even made it into the airbox at all.
While there may be some risk, unless he tries to ford a river, I think he'll be ok.