Paul Rowley has been confirmed as the new Castleford Tigers head coach after signing a three-year deal with the club.