This new musical based on the Kinks' songs and story proves an irresistibly enjoyable and touching night out, says Charles Spencer