Levelling up disadvantaged parts of the UK will require long-term thinking and investment, a new report says.