Tucked away in a quiet corner of Southampton, Solent Sky has been described as the city's best-kept secret