Given the noise you get from a typical contractor table saw (for example), It's going to be on your mind at some point.
If you're lucky enough to pick the right house in the first place....
Happy wife, happy life... Happy wife, happy life...
Then, you might be able to choose a place without neighbours, or maybe, they'll be far enough away that it won't be a problem.
If not, what else can you do?
Well, ideally, before you start to fill the space...
Check to see how much noise there is when your loudest machine is running and all doors and windows are shut. If you don't think you'll be able to get away with it, You'll want to add some noise abatement.
Typically you start with good insulation behind every wall.
Once you've done that. You're probably going to want to insulate and seal your garage door as well.
I made a YouTube video about that recently on 'got wood?'
Here' take a look and see what you think.
(Don't forget to like, subscribe and share please...)
If you're lucky by this point, noise levels will be low enough that all you'll need is a good relationship with your neighbours and you're set.
If your shop is still producing too much noise and you'd like to be on the safe side here are some great options for you to consider depending on your application.