Country singer Pat Green has shared his 'heartbreak' following the loss of multiple family members in the Texas floods, which have claimed more than 100 lives