The new novel from acclaimed musician James Yorkston leaves a lot to be desired, writes Stuart Kelly