A heartfelt new book details the friendship between friend and author Tom Piazza and beloved singer-songwriter