Having a new job now based in Norwich has placed me within close proximity within prime locations along the River Wensum and from Mousehold hill that gives views over the city. When looking for photo ideas I look at other people work on Flickr and http://www.shothotspot.com/. Also being a member of a local Facebook group also provides inspiration.
Another good way to find locations is to simply just walk around and keep in mind where you have been for future photo opportunities, I have walked along the river many times but I now know where the good places.
Even in my local town where I have been living for 15 years I am still discovering new locations.