Am I glad that Scotland stayed in the Union? Yes.
Do I think the UK is heading towards a federalist system? Yes. English votes for English laws means Scottish votes for Scottish laws, Welsh votes for Welsh laws, N. Ireland the same.
Will the Union survive that? In a new form, yes. There will be a unified foreign and military policy for instance.
Will the Union Jack become redundant? Yes.