From an all-night arts festival to an installation of yarn sculptures, this autumn brings a host of thought-provoking events