If you really want something for night fishing
, not just to look cool, for years I have used a pair of 500w spotlights clamprd to the handrail and pointing down into the water
about 45 degrees. It lights up a good area and attracts lots of bait and predators. They are removed after each use, easy to store and you can buy them at a hardware
store for about $15.00 each. On my trawler
I have an 8 KW generator
they work fine and I could add more if I wanted to. I used a similar set up on a 23' outboard fishing boat
2' 300 watt spotlights hooked to a 1kw portable generator
. The Honda
2 kw often recommended on this site would easily handle the 500 watt set and could have other uses.
There are abunch of 12V systems available as well, LED and sealed beams for above and underwater use. I tried 12V years ago before the LEDs were available the 12Vwas not very powerful so wore down quickly.
Good luck whatever you choose.