In his new book, Erik Piepenburg dishes on the US eateries that have served as LGBTQ+ havens and are still thriving