There are a lot of bricks and pieces on the web how to setup DNS for a local Site in SXA but no end to end description. At least I could not find it. Here's one from A-Z