The Prime Minister visits Aberdeen as a £250 million City Deal is unveiled that will overhaul the harbour to make it fit for cruise liners and decommissioning defunct oil rigs.