Loads of English people live here with no problem. And many even choose to vote SNP. Why do you think it wouldn't go well? Just don't go on about 1966 or call everyone 'sweaty jocks' or 'subsidy monkies' like some less egalitarian cliche-fuelled Southerners are wont to and I think you'll be fine.
I now quite like the idea of moving to lovely lefty Scotland, but I'm English. Would it go well?