Three Irish towns and cities have been branded “smarter travel destination areas” after beating off competition to receive a €23m investment in sustainable transport.