An invigorated movement of estate owners opening their doors is proving a crucible for creative inspiration and giving properties a soulful new purpose