Dalby Forest in Pickering and Brimham Rocks in Harrogate were among those suggested by locals as the best spots for stargazing in the county.