North-east council chiefs hope to cement the region as the ultimate cycling destination after an “unforgettable” weekend with Tour of Britain.