Police are investigating an overnight shooting that left one man injured in Durham's McDougald Terrace community.