If you want to have some applications only available to one user you could install them as user flatpaks or AppImages.
Personally I would just create two activities in KDE but you seem to want more separation.
Maybe encrypted home folders so that you can't easily access one from the other. Although permissions should be enough for that.