How much time does he get to himself? Tell him all the times. Tell him how mcu time you get to yourself. Tell him you'll probably be shopping, cleaning etc in the time you get away from the children. Ask him how long his lunchbreaks are.
Don't just cave into him. If he's in a bad mood when people visit, just ignore him, especially if they're your family.
When we first moved here 7 years ago, dh used to drive back to London once a month to gig. He'd leave on Thursday, gig on Friday night, stay up all night with his mate, maybe gig again on Saturday or Sunday, drive back Monday. Sleep until Tuesday afternoon. After a few months of this, I pointed out to him that once he felt fit for human consumption on Tuesday evening, I expected a full 3 days off, sleeping in, not running about after dd, not shopping, cooking, cleaning, washing up, supervising homework etc.
Funnily enough he started leaving on Friday and returning on Sunday.