Sid Hawke to be Ripon's next mayor