Macbook cannot find Magic Keyboard in Settings - Keyboard - configure bluetooh keyboard
It's not possible to do what you want with Apple's software:  System Preferences/Keyboard/Input Sources applies to all keyboards.  There may be a way to do it with the Karabiner app, see this earlier article:

Different key-maps/bindings for in-built keyboard and Bluetooth keyboard