Home renovation from Scratch

Hi All.
It’s been a while, but I have been building my requirements in order to start my lighting design.
Attached is a list of my requirements for the lights and switches. Also attached is plan of the house showing the device positions.
Lighting Requirements2.pdf (70.3 KB)
Device diagram2.pdf (406.0 KB)

Next I need to provide design circuitry to achieve the requirements to allow the electrician to install the cabling.
Can anyone help with this? So many different ways to achieve this. I want to provide a relatively low-cost solution using OpenHAB and decent HW products.
Any help/advice on the circuit design and assocaited components would be gratefully appreicated.
Regards,
Dan