The Scottish and Welsh governments have signed the landmark Cardiff Agreement, establishing a shared framework for policy co-operation and constitutional reform.