This is an important issue and drives all manner of other social problems and successes. We have similar problems in Shropshire (mixed in with the usual rural issues of sparsity, small communities and the cost of moving around). Doesn’t it really come down to shortage of supply. Build more houses, especially social rented house, and it will become easier to access them, it will also depress rents in the private sector which will be good for tenants (if not so much for landlords).
Though that takes money of course, which is in particularly short supply at the moment.