For an observer at the equator, where on the celestial sphere will the north celestial pole be located?

It will be where it always is on the celestial sphere - that will not change; but your perspective will change by your being located on the equator - face true north from the equator and the pole will be on the northern horizon