Rising big city rents and house prices plus the normalisation of online meetings and remote working are drawing many creatives to the countryside for a better quality of life. But investments in culture and tourism are boosting the attraction as well as generating a more vibrant creative ecosystem. Veronica Simpson reports