Best camera for low visibility?

[Mendicant]

I have never owned a camera other than the disposable camera I bought out of a vending machine in 5th grade, whatever is equipped on my smartphone, and the webcam on my laptop that has a piece of duct tape over the lens. (If you want to know why I keep duct tape on my webcam, ask some of the fellows who frequent the Politics/Religion section of Spearboard. They know a lot more about that stuff than I do.)

I would like to record my spearfishing adventures so that I may share them online (including such fine websites as Spearboard) but am new to the whole camera game.

Which model will work best for spearfishing in low vis conditions, such as below 2' or 3'?

Thank you in advance for your generous input.