Mayor demands more resources after Scots shot dead in Spain