Controversial author will serve as an executive producer on the forthcoming HBO TV adaptation, which is expected to debut in 2026