Statement from Buckingham Palace says the couple wants to 'carve out a progressive new role,' work to become financially independent