The 17749 is what I run on my '64 GTO convertible with a healthy 462 with a Crower 60243 cam. I wanted something quiet enough on the highway that I can hear the car stereo. In the parking lot or a stop light, the 17749 let people know there is a healthy V8 with some cam in it, but they are not obnoxious.
A 'throaty sound that makes heads turn in a parking lot' won't be possible with a 389 built to stock specs and a mild cam if you want it to be quiet in normal driving. To get your desired sound in the parking lot will require a muffler that is obnoxious all the time. If you want the parking lot sound without all the noise when driving down the road, invest in some exhaust cutouts.
Link to Summit exhaust cutouts:
https://www.summitracing.com/search/...style/electric
Summit has the 17749's and the cutouts.
For a stock engine any muffler shop can bend the pipes to make your complete system.
If you want to do the entire install yourself - Summit has the Pypes complete with muffler exhaust systems for sale for under $600 with your choice of three different mufflers, or under $500 without mufflers.
The Street Pro muffler, the Violator and the Race Pro mufflers are your choices. The Street Pro would be louder than stock, but milder then the Violator or the Race Pro.
https://www.summitracing.com/search/...model/catalina
Your $1200 budget should be more than enough, even if you opt for the cut outs.