The old 3e sourcebook Waterdeep: City of Splendors lists all the guilds in the city. There might be something in Rise of Tiamat since the Council meets in Waterdeep. I think alas you will have to scour the Tavern chapter of Dragon Heist with a fine-toothed comb to compile a list, and it will still be partial.