Southeast Queensland looks set to be awarded the biggest City Deal in the country, with Scott Morrison revealing support for an ambitious plan to modernise the region.