Good places to live with a young family

Hey, my husband and I currently live in Scotland, I'm pregnant and due in Spring. We love living here but we are thinking of moving to Cumbria to be closer to our parents now our family is growing (we're English and his parents live in North Yorkshire).

Are there any places in Cumbria that you would recommend to live in with a young family? Ideally, a place with a strong community that isn't also too large? More affordable recommendations would also be appreciated if possible. Sedbergh is a town that's caught our eye so far.

Thanks in advance!

Edit: Also, to add that we don't want to be too far from the M6 so that it's easier for us to visit family, thanks again!