Kaye’s Goin’ Local, which includes a song co-written with Smith, shows off a new side of the legendary musician