A former social and sports club on the edge of Bristol is set to take on a new lease of life.