A landscape garden inspired by Wigan’s history and the climate emergency has officially opened to the public