The Conservative leader of Ribble Valley Council is to step down from the position after six years and hopes to take on a new role.