Former PM Gordon Brown will team with city leaders to warn against the impact of Brexit on Northern cities