Tourism leaders from Chester and Wrexham have pledged to work closely together to attract more visitors.