Integrated kitchen/dining

I have been racking my brain over how to reconfigure the kitchen and I haven't come up with a single good solution so far. The house doesn't have a lot of light so I want to remove the kitchen wall that backs onto the front living room and make it a little more open plan. The problem with that is that you would then be able to see the kitchen sink from the front door!

I found a picture today that possibly has some potential. I like how it integrates casual dining space with the kitchen and dresses it up a bit. It doesn't exactly solve my problem but it's got something.