Scalar-Gauss-Bonnet Theories: Evasion of No-Hair Theorems and novel black-hole solutions