The WNBA’s Connecticut Sun are set to relocate to Houston as part of a blockbuster multi-million dollar deal