New waterfront theatre set to open at Esplanade in October