The singer, 31, who has left fans fraught with fears over his mental health, substance use and his relationship in recent months, flashed a huge smile as he welcomed guests