Personally I am a fan of the super majority approach, that being 55 or 60% or more of the vote being required for a significant change. The issue with the vote like this is it is literally divided at almost 50% (with a 70% voter turnout). It will leave scars no matter who won, and depending on what happens, might still leave more (i.e. how everything is decided to turn out, the initial vote to leave is the beginning of a long and potentially very painful process).
As mentioned by Sentryduty Canadadoesn't do these types of referendums much (last one as mentioned was the Quebec separation vote in the 90s) and that was voted down so there was no hard choices that had to be made. The next one will likely be to change the voting system (if they choose to do a referendum, unfortunately legally they are not required to) so we will see what happens there as there might be more than one option on the ballot, and it will be hard to figure out a clear winner.