Heya, I have Aries in a 2 bed apartment in central London and so far it's worked out alright. Like Jackie said, it's very doable as long as you put the time and effort into it to keep them occupied and happy. Huskies don't generally bark, and Aries only really gets talkative when he's really excited (say during tug of war he'll growl and jump around or "talk at you" when we play hide and seek but its never louder than the tv normally is for instance), so on the noise front I've never really had an issue except for when a fox or cat decided to walk slowly past the window. That usually results in a few whines or a loudish woo-woo-woo and some running from window to window, but it's nothing I've had neighbours complain about. I also moved after a year, and in both places no one said anything about those kinds of noises.
In all fairness you're never going to keep yours quiet all the time, but from my experience the issue will be bigger when they're younger. Another thing to consider is separation anxiety. Aries used to have separation anxiety when he was really young and would howl and cry for about 10 mins straight at times when he was left alone. It didn't last particularly long, maybe about 1.5-2 months, but it's something to consider. I was also in part responsible, as we hardly left him alone for the first month since we got him and he got too used to us around . If you adopt, all I can say is make sure you get to know the dog first! Additionally, older dogs are also a bit more docile than the younger ones, so adopting an adult/senior puts you at a bit of an advantage.
Other than that, if your husband's family owns the flat and they're fine with it, even if he is loud from time to time, there is not much the neighbours can do about it. If you were renting, you'd risk breaking the terms and conditions of your contact on social consideration, so if you own the worst they can do is complain to a building general manager if there is one. Even in that case, I'm not sure exactly how much they can do considering the flat isn't rented. I'm not advocating being a bad neighbour, but its worth assessing your situation for a "what's the worst the could happen if they weren't happy" perspective.
All in all, its possible