The English actor became a cult icon as Dr Frank-N-Furter and later terrified audiences as Stephen King's Pennywise