First, listen to Boots.
What you want can be done but seems like a lot of digging and piping.
Fairly easy if you are going to manually switch between the sources, bit complicated if you want automatic switching.
Put in your RPZ, add a ball valve on the main line, T in your lake source after that ball valve, have a ball valve on the lake source, have fun.