Towards efficient and accurate ab initio solutions to periodic systems via transcorrelation and coupled cluster theory