To show you that this sort of chandelier arrangement can work, I went and gathered some pictures from right here on Houzz with similar situations:








(It's hard to see in this one, but there's a chandelier with a drum pendant over the table)


In the end, you need to go with what you love. It's your home, you are building it and so you deserve to have exactly what you want. I think the two different fixtures will work together and help visually signify the uses for each area they light.

Let us know if you need more help or advice!