Paul Rowley takes over as Castleford Tigers head coach, with the former St Helens boss signing a three-year contract.