I agree with the v helpful advice from other posters.
Is he a daschund? And how old is he?
Your dog needs training to settle elsewhere with a command “bed”. Bed needs to become a positive reward. A safe cosy space. Not a punishment.
So if you are working during the day, train him to lie in a bed away from you in your office. Start with him nearer and gradually move his bed further and further away. Line the bed with a t-shirt or two that you have slept in initially.
These one or two “safe” areas in your home must be made very comfortable and appealing. You could try a big roomy crate with toys and a bed in the corner of the kitchen or sitting room for example. Maybe a radio with calming classical music, You can start by putting him in the crate for just a minute and then removing him, Keep it up and keep lengthening the time by a few minutes. Lots of praise when he settles. Then try the same training with the crate door open.. And you move further away, He should soon come to enjoy having his own space.
You can also train him to “bed” each time the doorbell rings before you open the door, so it becomes his safe space.
If he is not responsive to food rewards, have you tried a squeaky toy?
Also you could stop being the one in your family who walks and feeds him and delegate those duties to someone else?
Literally ignore him when he fusses, turn your back, arms across your body, don’t look at him, and ONLY stroke and reward when he is in a calm and settled state. Especially when leaving the home and returning, Be very calm and try and be as non-vocal as possible.
Your body language, is all-important here op Remember the three Cs;
-calmness in your breathing
-clarity of your instruction
-confidence in your intention.
If you are giving instructions for him to go to his bed, while at the same time feeling guilty about sending him there, the training won’t work because he will sense your anxiety and it will make him afraid and cautious. You have to exude inner zen and calm positivity! 😃. Similarly, getting stressed when he is around you will up his anxiety levels and make him want to be with you more.
Finally, yes, make sure he has lots of your attention for 10 minutes x3 in a little morning, afternoon and evening routine, a bit like you would develop with a baby. Play, eat , rest, walk, sleep. Or however you want to order it. It’s a lot of work but worth it in the end because they can relax more when they can predict what is coming.
Obviously, if he is an older dog who isn’t likely to improve, and your mh is being seriously affected by him smothering you, then you need to return him to his breeder to re-home responsibly but as that is likely to be very traumatic for the dog, please give the methods above a good try, perhaps with the support of a trainer initially. Good luck!
Edited to add: a frequent mistake is that people praise the dog too much and too excitedly when they obey a command. If you watch a bitch with it’s puppy which is crawling all over it, she nips it, or growls a bit to get it to back off, but she doesn’t “reward” with any more sounds or touch after they obey.