The first-term mayor’s admission follows the painful loss of the Barrys’ only son, Max, in July after an overdose on a combination of several drugs, including two opioids