Detection of local non-Gaussianity with future observations