This largely depends on the bag and the type of bag you choose. They will all be somewhat water-resistant, to begin with, but the hard cases tend to be better when it comes to bearing the elements.
The soft material will be okay, but it will retain some water, and there will be some leaking with most units. The hard cases will not have this issue and will usually be better in the rain.