Hi Daphne and welcome!!
nice looking car! yes, to get the sound you want you're going to want to get some headers. There are 2 types- long tube and short tube. Most opinions are that long tube headers will give more flow; more power and sound. They're harder to fit and more costly. Look around in this thread for a myriad of stories of each:
https://www.camaro5.com/forums/forumdisplay.php?f=11 As far as brands- that's up to your wallet. Many people here will lean towards Kooks or American Racing Headers. Both are top notch and can be had from the vendors on this site or Summit/Jegs. . I feel, in reality though, there are probably more examples of Speed Engineering headers because they're cheap, and well... they get the job done. You can find them on eBay.
Don't be afraid to ask questions when they arise