This sounds complex to me, I don’t know how many connections (one per council? one for everything) there are. You can do duplicate emails if you have multiple connections. I’d need a lot more info to give good advice, not something that is easily done in a forum.
This sounds like you’d benefit from Auth0 professional services: Auth0 Professional Services
John