The Union 'is over' as we know it and should become a 'voluntary association' of nations, claims Welsh Labour leader