Unfortunately, no such functionality exists. Google accounts (as well as other accounts, such as Signal) are handled by the OS's Account Manager, which contains account auth info & other details that can be accessed by their respective apps - in this case, Google Photos, Google Play, Google Services, etc. They are per-profile, however. You could install Photos & Play services on another profile using the "Install available apps" feature and have the photos on that profile with no account signed in, but you may find that cumbersome if you don't actively use that profile.