A former Labor minister and party powerbroker has landed a new role sorting out the state’s most remote – and embattled – councils – in what he says will be a monumental challenge