NOTE: I goofed! I have edited my prior post by changing the name of the included box to ...CORE, not ...Pro. (CORE is the newer Corsair product that combines the functions of two previous boxes into one.)
The Lighting Node CORE does it. It has one cable to connect to a SATA power output connector from your PSU for power for all the items plugged into it, and a cable you connect between it and a mobo USB2 header. Then you plug all your fans into this box. Then you run the iCUE software utility. It communicates with that box. It also gets info from your mobo about the CPU and mobo temperature sensors, and can get fan speed info from the box. The software takes over management of the fan motor speeds, and also of the fan lighting displays, conveying its instructions via the USB2 cable to the Lighting Node CORE box. So no mobo headers are involved in either of thse functions And the CORE box supplies all the power for both sets of functions to the fans plugged into it.