Hampshire County Council's cabinet have dropped plans to turn a much-loved activity centre into a children's home in a huge victory for campaigners.