Take the pic with you to wherever you bought that first one (probably a place with a lot of chinese knockoffs mixed in with regular goods), ask for that, say no when they offer the closest pipe to you at that time saying it's just as good/better, insist on what you want and maybe they will have a second, somewhere in the back.
Custom flavors are generally just flavor mixes the lounge people come up with that they enjoy. MYA hookahs are generally pretty good stuff, easy to wash etc. Just make sure you also have washable hoses so as not to get gunky rusty shit in your customers mouth/lungs. And make sure to have natural coals, none of that quicklight bullshit. As for brands, I'm a nakhla original and nakhla mizo guy, sometimes I delve into the few good Al Fakher flavors or if I have a rare possibility to get Tangiers at a low price (in the EU, shit's hard). I reckon Tangiers is the best you can get but also the most difficult to manage and pack right, so if you're not totally on point with your packing and shit yet, maybe go for something more simple, as I said I swear by mizo most of the time. I've had Starbuzz and Fantasia and they were both OK but not quite up to the hype. However there is a lot more people who know about those and have believed the marketing, so it might draw in more people.
Hookah and alcohol don't go together well in a lounge setting anyway, drunk people and hot coals = potential disaster! What's the atmosphere you're going for? Also, I'd avoid multi hose setups if I were you, they have more potential points of failure which is not what you want. You'd probably want high quality solid pipes just in case shit gets knocked over etc.
If you're buying local made just check in and ask what the problem is. It could not be acclimated well or it could be something on your and with the pack though, if this is a flavor that you haven't had yet it might need to be packed differently, if it's ultra wet go fluffy as shit and see what happens.