There are several options...
Here’s one example-
https://www.ledsupply.com/led-strips...RoCeK0QAvD_BwE
LED’s come in several sizes, lumens, colors, lengths, knowing and understanding the differences will help narrow down your options.
The example above comes with a power cord that has a built-in DC rectifier. But you don’t have to use the power cord. You could direct wire the rectifier inside a two gang box. I’ve done cabinets this way. I’ve also tapped the dishwasher or disposal circuit and run wire to the top of the cabinets and used a transformer box set on top.
Since you’re going to the ceiling- that most likely wouldn’t work- but there are other options; like having the j-box in a base (sink) cabinet- wiring up through the back wall. Power and wiring have many options- picking the right LED strip(s) is much more complicated- along with accessories to connect it all together!