You can find Pickman's Gallery in the North End of the Fallout 4 map.