A split between Spain and Catalonia would cause a major political shake-up in the country but would also have significant consequences for the economy of both sides, experts have told CNBC.