Residents in an area where a man was shot in Southampton say that the “tight-knit community” will “bounce back” after the incident