'Democracy is at stake' says Scottish leader after UK Supreme Court denies referendum right