The sub-galactic and nuclear main sequences for local star-forming galaxies