You said "Turn Night Into Day", but I don't see why you'd really want that. Paddling is fun and all, but at any time it could instantly turn into a life or death situation, especially at night. It would be a lot smarter to preserve your night vision. But if you must... Any of the pop-can 4x18650's designed for flood would fit the bill. I don't think any of them have extreme water protection.
The TN36 or MM18 immediately come to mind. There are others.
Personally, I would not take any light on a paddle if it does not FLOAT IN WATER. If it doesn't float, it's gonna get lost in the drink. Count on it.
You don't want a dive light, and you don't want something that will completely destroy your night vision because you are out there for hours and you need to see what's on the side too.
Every ounce counts to keep you above the waterline and your boat more responsive to each stroke.
I take two of the HybridLight 100 lumen models, and use gaffer tape to attach them to my bow, aiming out at about a 15 degree angle. Then use a third one for everything handheld. That's all i need for a three day river trip. They recharge themselves during the day. Mine are doing great after six years, used at least three trips a year. They really are tough little *******s, and you can't even take them apart. No batteries to get lost, simplifies packing, no worries at all, really.
Today, you've got a choice of more powerful models, 160 or 250 lumen, and they'll charge your phone too. Just make sure you get genuine HybridLight, there's definitely counterfeit product out there.
I've got a few much more powerful lights but I leave them at home for water trips. If i was going to take any of them it would be my elzetta charlie with both throw and flood lenses. I definitely see an occasional need for an extreme thrower, and my Niwalker Vostro will put a spot on something half a mile away, but it's just too much weight and would have to be handled with care around water.