Twiglett ... I had a second c-section 2 weeks ago.
Like you I'm a SAHM and have only ever spent 1 night away from DS who is 26 mths. He stayed with my sister the night before section as hospital is 90 miles away and we went the night before. He had stayed with sis once before and was fine that time - this time he was unsettled but it was only 24 hrs and he survived.
Last time I was in hospital for 7 nights following planned section, this time for only 4 nights. Recovery much faster this time round though I haven't lifted DS yet and don't intend to unless I have to whilst DH is off work.
DH looked after DS whilst I was in hospital. I left a freezer full of food and pages of lists of about clothes, washing, food, nursery etc etc. They survived and lived to tell the tale! Two weeks on DS is a bit upside down as he's refusing to take his usual 2 hr afternoon nap but we're working on that - he loves his baby brother and after a day or so huffing with me (maybe a week after I came home) he's fine with me too but is really enjoying spending lots of time with his Daddy!
Good luck with your section ... when are you due?