"How far can bullets travel when fired into water?" Their conclusion:

So the general rule is that most ordinary guns and bullets aren't tremendously effective when fired into the water, and if you can dive below eight feet, you're probably safe from your run-of-the mill assassins. But if you've incurred the wrath of the Bundeswehr, all bets are off. You may as well stay dry and meet your fate like a man.