Tracy, no obvious connection at the moment. My family seem to be based around the Hull area which is in east Yorkshire and, it appears, moved from the Nottingham area in the early 1800's. Nottingham had, and still does have, many Marriotts.
Sheffield is in South Yorkshire but you're quite corect, there is a village called Dinnington in the area. I did a quick search on the web and found reference to a Wilfred Marriott who died during World War 2 and is listed on the Dinnington Village war memorial.