Scotland have been offered a multi-million-pound investment from Commonwealth Games Australia to help save the 2026 Commonwealth Games.