(less than great advice given here from the saltwater divers... freshwater/green water is a different beast)
For Northeast fresh water (Lake George, Lake Champlain, etc.) a bright pinpoint 1,000 lumen is the basic go to light.
I have a Salvo 35W HID Canister light I’d be happy to offload