Is there a way to set multiple passwords for a single account on macOS?
No, one password per account. You can authenticate as another user anytime the GUI asks for authorization, overriding the current user as the default choice, but there’s one correct password per account.